home *** CD-ROM | disk | FTP | other *** search
- MIRR (Modified Internal Rate of Return)
- Calculates the modified internal rate of return (MIRR) of a series of cash flows, given safe and risk investment rates.
-
- Format: MIRR (safe, risk, values,...)
-
- Arguments:
- ΓÇó safe: Rate returned by the investment that finances the negative cash flows.
- ΓÇó risk: Rate at which the positive cash flows can be reinvested.
- ΓÇó values: Future cash flows (ranges can be used for values).
-
- Example:
- MIRR (10,15,-5000,2000,4000,-2000,5000) returns 19.66 (when using the Percent format).
- This MIRR results from the cash flow values shown, a safe rate of 10, and a risk rate of 15.